| Variable Name | Datatype | No of Unique | Samples | Mean | Standard Deviation | Min | 25th percentile | Median | 75th percentile | Max | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | brand | float64 | 12 | [138.12816902184844, 16.586315789473684, 85.22611019283747, 13.606181818181817, 59.16286149162862] | 135.240267 | 15.249867 | 13.606182 | 138.128169 | 138.128169 | 138.128169 | 138.128169 |
| 1 | business_unit | float64 | 11 | [900.0, 904.0, 922.0, 326.9672252788773, 700.0] | 868.795242 | 129.490226 | 326.967225 | 900.000000 | 900.000000 | 900.000000 | 935.000000 |
| 2 | carrier | float64 | 15 | [137.59597888324086, 191.49655934793682, 66.11952078239608, 102.37927751834557, 65.85477833500501] | 135.240338 | 14.050647 | 16.473234 | 137.595979 | 137.595979 | 137.595979 | 191.496559 |
| 3 | channel | float64 | 12 | [132.12089741445845, 90.69040233666061, 146.6541923213651, 399.48484595744685, 415.91636363636366] | 135.239547 | 39.330593 | 68.406667 | 132.120897 | 132.120897 | 132.120897 | 451.709459 |
| 4 | color | float64 | 35 | [138.2489639738742, 153.49555624450124, 58.65695707295374, 143.25272264133372, 103.57299342820437] | 135.241919 | 36.475295 | 14.250001 | 120.758911 | 143.252723 | 148.029814 | 507.777778 |
| 5 | condition | float64 | 24 | [110.1420661978082, 100.95723477538753, 120.34295941861212, 202.48760250482823, 195.4376402502607] | 135.240293 | 45.588549 | 7.664739 | 110.142066 | 110.142066 | 165.638901 | 681.320533 |
| 6 | customername | float64 | 197 | [203.88263665594855, 104.64329451314684, 110.24723987955838, 106.62826773915542, 99.73694118344599] | 135.211255 | 54.740485 | 5.446018 | 104.185756 | 118.127116 | 158.417419 | 730.104660 |
| 7 | days_since_last_purchase | float64 | 8 | [0.0, 6.901077520042098, 1.0, 3.0, 5.0] | 0.068330 | 0.609191 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 6.901078 |
| 8 | ext_grade | float64 | 11 | [116.82105894128114, 100.95162724396995, 120.30596259159275, 201.2409261140236, 195.4376402502607] | 135.239551 | 43.722060 | 16.471370 | 116.821059 | 116.821059 | 120.305963 | 451.709459 |
| 9 | ext_model_family | float64 | 108 | [143.18562048261018, 77.99445567562398, 108.76040296433534, 88.52858636637843, 52.97862225938313] | 135.258627 | 103.975019 | 10.041999 | 77.994456 | 98.560790 | 161.344978 | 819.720986 |
| 10 | first_time_customer | float64 | 2 | [0.0, 0.5474062583119533] | 0.016757 | 0.094299 | 0.000000 | 0.000000 | 0.000000 | 0.000000 | 0.547406 |
| 11 | gp | float64 | 47795 | [950.97, -159.99, 41.91, 238.91, 26.62] | 124.104790 | 2011.964833 | -27946.697006 | 2.220000 | 40.750000 | 130.675000 | 28036.414318 |
| 12 | inventory_id | float64 | 5959 | [141.9742571428571, 59.92203050847458, 106.47787610619469, 87.042071197411, 52.97278911564626] | 134.485898 | 104.886491 | 5.322033 | 65.631579 | 106.477876 | 157.350000 | 996.294230 |
| 13 | invoice_no | float64 | 8597 | [46433646.0, 48837430.0, 53031002.0, 49395706.0, 51028583.0] | 50056654.705307 | 2658659.577362 | 44807541.000000 | 47929636.000000 | 50327686.000000 | 52301527.000000 | 54838649.000000 |
| 14 | line | float64 | 535 | [21000.0, 34000.0, 20000.0, 74000.0, 51000.0] | 40606.026379 | 56315.186413 | 1000.000000 | 8000.000000 | 20000.000000 | 46000.000000 | 256331.386539 |
| 15 | lock_status | float64 | 3 | [135.23206602138754, 137.17599248443202, 84.30587341772151] | 135.239263 | 1.748123 | 84.305873 | 135.232066 | 135.232066 | 135.232066 | 137.175992 |
| 16 | manufacturer | float64 | 14 | [138.12863927831825, 16.586315789473684, 85.22329385844121, 13.606181818181817, 59.16286149162862] | 135.241505 | 15.244540 | 13.606182 | 138.128639 | 138.128639 | 138.128639 | 138.128639 |
| 17 | memory_size | float64 | 12 | [110.84185308027186, 72.01804319654427, 84.34933772269558, 179.52871822004528, 155.5821439437734] | 135.239263 | 67.911644 | 23.378892 | 84.349338 | 110.841853 | 155.582144 | 467.777803 |
| 18 | model_family | float64 | 193 | [139.79359246088194, 69.55733681145352, 106.50990083905417, 86.0514243792325, 48.217917996870106] | 135.275650 | 105.512392 | 8.369396 | 69.557337 | 98.612845 | 156.515299 | 866.183125 |
| 19 | order_no | float64 | 8442 | [28233583.0, 29051595.0, 30899081.0, 29168877.0, 29926902.0] | 29566310.850768 | 1063132.991064 | 26365219.468090 | 28705845.000000 | 29595948.000000 | 30518500.000000 | 31764238.000000 |
| 20 | order_type | float64 | 4 | [133.41467696068688, 196.27701867995017, 232.54545447167152, 306.783951098094] | 135.238765 | 10.597951 | 133.414677 | 133.414677 | 133.414677 | 133.414677 | 306.783951 |
| 21 | quantity | float64 | 408 | [100.0, 20.0, 1.0, 8.0, 2.0] | 11.322457 | 39.459004 | -350.256143 | 1.000000 | 2.000000 | 7.000000 | 381.552260 |
| 22 | sales_person | float64 | 16 | [149.05817598516106, 119.85298332309411, 145.4403729333729, 216.8189755122439, 210.42307692307693] | 135.239225 | 28.857251 | 70.436637 | 119.852983 | 119.852983 | 149.058176 | 504.137931 |
| 23 | selling_cost | float64 | 58229 | [16049.03, 1259.99, 68.09, 465.09, 75.38] | 2066.367236 | 11902.049434 | -148570.780461 | 88.785000 | 216.280000 | 629.980000 | 155347.159241 |
| 24 | selling_price | float64 | 10612 | [17000.0, 1100.0, 110.0, 704.0, 102.0] | 2150.514092 | 11379.535166 | -133819.776821 | 110.000000 | 270.000000 | 770.000000 | 140685.872913 |
| 25 | sku | float64 | 5989 | [141.9742571428571, 59.92203050847458, 106.47787610619469, 87.042071197411, 52.97278911564626] | 134.274433 | 104.233614 | 5.322033 | 65.631579 | 106.265851 | 157.846154 | 990.576083 |
| 26 | source_channel | float64 | 5 | [132.12098856968313, 109.44762998355134, 399.48484595744685, 415.91636363636366, 451.7094594594595] | 135.239263 | 38.051070 | 109.447630 | 132.120989 | 132.120989 | 132.120989 | 451.709459 |
| 27 | tgt_enc_sim_impt_x0 | float64 | 6 | [128.0682946896036, 162.70607912677693, 82.85306886929344, 110.55211495629797, 171.44040834473324] | 135.239263 | 26.723399 | 52.589796 | 128.068295 | 128.068295 | 162.706079 | 171.440408 |
| 28 | tgt_enc_sim_impt_x1 | float64 | 4 | [130.0019700247023, 197.18144309371112, 139.89883877221325, 135.23926336639326] | 135.239551 | 17.660094 | 130.001970 | 130.001970 | 130.001970 | 130.001970 | 197.181443 |
| 29 | tgt_enc_sim_impt_x2 | float64 | 177 | [142.45596918511757, 78.99624829584185, 105.99506735751297, 81.79102022315203, 57.04693107344633] | 135.255840 | 100.681855 | 7.369442 | 79.315704 | 96.965945 | 160.409558 | 828.015191 |
| 30 | unit_cost | float64 | 40243 | [160.49, 62.999, 68.086, 58.136, 37.691] | 109.161616 | 87.273855 | 0.000000 | 49.865000 | 80.354000 | 139.534500 | 418.545324 |
No categorical columns
No categorical variables in data.